Introduction to Filters in Tableau

Topic: Introduction to Filters in Tableau

Objective: Understand the purpose of filters, learn how to filter dimensions, measures, and dates, create interactive filter controls, and use filters to analyze relevant data in Tableau worksheets and dashboards.

Course Link: JustAcademy Tableau Training

Demo Link: Register for a Tableau Course Demo

1. Introduction to Filters in Tableau

Filters in Tableau are used to limit the data displayed in a visualization according to specific conditions. They help users focus on relevant information instead of displaying every record in a dataset.

For example, a retail company may have sales data for multiple years, regions, product categories, and customers. A manager may want to view only sales from 2025, only the West region, or products whose sales exceed a particular amount. Filters make these analyses possible without requiring users to create a separate dataset for every requirement.

Filtering can be performed on dimensions, measures, dates, and other supported fields. Tableau also allows users to display filter controls so that viewers can interact with a worksheet or dashboard and change the information they see.

Example

Consider the following sales dataset:

If the manager filters the data to show only the West region, the relevant records are:

The filtered view makes it easier to analyze the selected region without unrelated regional records appearing in the result.

2. Why Are Filters Important in Tableau?

Filters are essential for interactive data analysis because they help users reduce unnecessary information, investigate specific business questions, and create focused visualizations.

2.1 Focus on Relevant Data

A large dataset may contain thousands or millions of records. Filters help users display only the records relevant to their current analysis.

2.2 Compare Business Performance

Users can filter sales by region, profit by category, or orders by year to compare performance across different business segments.

2.3 Create Interactive Dashboards

Interactive filters allow dashboard viewers to select regions, dates, categories, or other values without editing the underlying workbook.

2.4 Analyze Specific Periods

Date filters can restrict a report to a particular year, quarter, month, date range, or relative period such as the last 30 days.

2.5 Investigate Business Problems

Filters can help identify low-profit products, high-value customers, delayed orders, and regions with weak performance.

2.6 Support Decision-Making

By narrowing the analysis to a relevant subset of data, filters help decision-makers investigate trends and make informed business decisions.

Business Example

A sales manager wants to investigate why profit declined in one region. The manager can filter the dashboard to that region, select a specific year, and review sales by product category to identify possible causes.

3. Understanding Dimensions and Measures Before Filtering

Before creating filters, it is important to understand the difference between dimensions and measures in Tableau.

3.1 Dimensions

Dimensions are fields that describe, categorize, or identify data. They commonly contain text values, categories, names, locations, or date parts.

Examples:

• Region
• Product Name
• Category
• Customer Name
• Department
• Order Date

Filtering a dimension often means selecting which members should remain in the view. For example, a Region filter may include only East and West.

3.2 Measures

Measures are quantitative fields that can be aggregated or analyzed numerically.

Examples:

• Sales
• Profit
• Quantity
• Discount
• Revenue
• Shipping Cost

Filtering a measure often means specifying a numerical range or condition. For example, a Sales filter may include values between 10,000 and 50,000.

4. What Is a Filter in Tableau?

A filter is a rule that determines which data is included in a view or which marks are displayed. When a filter is applied, Tableau evaluates the configured criteria and displays the results that satisfy them.

For example, if a worksheet contains sales for ten product categories, applying a Category filter that includes only Technology restricts the displayed analysis to that category.

Basic Filter Example

Suppose the dataset contains the following categories:

• Furniture
• Office Supplies
• Technology

If Technology is selected in the filter, the view displays the data matching Technology while excluding the other categories from that filtered view.

Important: A worksheet filter does not necessarily delete records from the original data source. It controls which data is used or displayed at a particular stage of Tableau's processing.

5. Main Types of Filters in Tableau

Tableau supports several filter types. They operate at different stages of data processing and serve different analytical purposes.

These filter types are not interchangeable. The correct choice depends on the data, the business question, and when the filter must be applied.

6. How to Create a Filter in Tableau

One common way to create a filter is to drag a field from the Data pane to the Filters shelf.

General Steps

1. Open Tableau Desktop or a supported Tableau authoring environment.
2. Connect to a dataset, such as a sales spreadsheet or database.
3. Open a worksheet.
4. Locate the field you want to filter in the Data pane.
5. Drag the field to the Filters shelf.
6. Configure the options in the Filter dialog box.
7. Choose the values or conditions to include or exclude.
8. Click OK or apply the selection.
9. Review the visualization to confirm that the filter works as intended.

Example

To display sales only for the West region:

1. Drag Region to the Filters shelf.
2. Select West in the Filter dialog box.
3. Confirm the selection.
4. Review the view to ensure that only the West region is included.

The Filter dialog box changes depending on whether the selected field is a dimension, measure, or date field.

7. Filtering Categorical Data Using Dimensions

Dimension filters are used to include or exclude selected members of a categorical field. Common examples include filtering by region, category, product, customer, department, or order status.

7.1 General Tab

The General tab allows users to select which dimension members to include or exclude.

Steps

1. Drag a dimension, such as Category, to the Filters shelf.
2. Open the General tab in the Filter dialog box.
3. Select the members you want to include, or configure exclusions as required.
4. Click OK.
5. Verify the resulting view.

Example

A report contains Furniture, Office Supplies, and Technology. Selecting Technology includes that category in the filtered view.

7.2 Wildcard Tab

The Wildcard tab allows users to filter text members according to a pattern.

For example, a user may want to select product names that begin with a particular sequence of characters.

Example Patterns

The asterisk (*) represents a sequence of characters. Wildcard matching is useful for searching text values without selecting every matching member individually.

7.3 Condition Tab

The Condition tab allows a dimension filter to be based on a condition, such as a calculation involving a measure.

Example: A business wants to display only customers whose total sales exceed a specified threshold. A condition can be configured to select customers based on an appropriate sales calculation.

7.4 Top Tab

The Top tab allows users to restrict a dimension to a selected number of members based on a measure or another supported ranking rule.

Example: Display the top 10 customers by SUM(Sales).

Steps to Create a Top N Filter

1. Drag Customer Name to the Filters shelf.
2. Open the Top tab in the Filter dialog box.
3. Choose the option to filter by a specified number of top members.
4. Enter the required number, such as 10.
5. Choose the measure used for ranking, such as Sales.
6. Select the appropriate aggregation, such as SUM.
7. Apply the filter and review the resulting customers.

Important: The General, Wildcard, Condition, and Top tabs can work together. Their settings are additive, so the final filter result must satisfy the applicable configurations.

8. Filtering Numerical Data Using Measures

Measure filters allow users to restrict numerical data according to a range or threshold. They are commonly used for sales, profit, quantity, revenue, cost, and other numeric fields.

Common Measure Filter Options

Steps to Create a Measure Filter

1. Drag a measure, such as Sales, to the Filters shelf.
2. Select the appropriate aggregation when prompted.
3. Click Next to open the numerical filtering options.
4. Choose a range or threshold option.
5. Enter the required values.
6. Apply the filter and verify the view.

Example: Sales Between 20,000 and 60,000

After applying a Sales range from 20,000 to 60,000, the remaining values are:

Note: The results depend on whether the filter applies to underlying values or an aggregated measure in the view. Confirm the selected aggregation and filtering behavior.

9. Filtering Date Fields

Date filters help users analyze data for specific dates, periods, or time ranges. They are useful for monthly reports, quarterly analysis, year-over-year comparisons, and recent activity monitoring.

9.1 Relative Date Filter

A relative date filter selects dates relative to the current date or another supported anchor date. It is useful for reports that should update over time.

Examples:

• Orders from the last 30 days.
• Sales from the previous quarter.
• Records from the current year.
• Tasks completed last week.

9.2 Range of Dates

A range-of-dates filter allows users to specify a start date and an end date.

Example: Display orders placed between 1 January 2025 and 31 March 2025.

9.3 Discrete Date Filter

A discrete date filter allows users to select specific date parts or values, such as particular years, quarters, or months, depending on the field configuration.

Example: Display only Q1 and Q2 when analyzing quarterly performance.

9.4 Individual Dates

Individual date filtering allows users to select specific calendar dates from the available data.

Example: Display transactions recorded on 15 March 2025 and 20 March 2025.

Steps to Create a Date Filter

1. Drag Order Date to the Filters shelf.
2. Choose the desired date-filtering option.
3. Select a relative period, date range, date part, or individual dates.
4. Confirm the selected values.
5. Apply the filter.
6. Verify that the view contains the intended date period.

Important: A relative date filter can change as time passes. A fixed date-range filter remains tied to the specified dates unless its settings are changed.

10. Context Filters in Tableau

A context filter establishes a primary subset of data for a worksheet. Other relevant filters, such as dimension filters, are then evaluated against that context.

Context filters are useful when a business question requires one condition to be applied before another filter, especially in Top N analysis.

Example

A manager wants the top 10 customers by sales in the West region. The goal is to identify the top 10 customers within the West region, not the top 10 customers across the entire dataset.

Steps

1. Drag Region to the Filters shelf.
2. Select West.
3. Right-click the Region filter on the Filters shelf.
4. Select Add to Context.
5. Drag Customer Name to the Filters shelf.
6. Configure a Top 10 filter based on SUM(Sales).
7. Review the result to confirm that the ranking is calculated within the selected region.

Important: A context filter is not required for every worksheet. Use it when the filter execution order needs to change the meaning of the analysis, and test the result to confirm the intended behavior.

11. Extract Filters and Data Source Filters

11.1 Extract Filters

An extract filter limits the data included when creating or refreshing a Tableau extract. It can help reduce the amount of data stored in the extract.

Example: An organization needs only records from the last five years in its extract, so it configures an appropriate date restriction before creating or refreshing the extract.

11.2 Data Source Filters

A data source filter restricts which data is available from a data source to the workbook. It is useful when a workbook should consistently use a limited subset of records.

Example: A report is designed to analyze only a particular business unit or a defined set of regions.

12. Table Calculation Filters

Table calculation filters operate on the results of table calculations. They are applied late in Tableau's order of operations and generally hide marks from the view rather than removing the underlying data used to compute the table calculation.

Example: A worksheet calculates the rank of each product by sales. A table calculation filter can display only the products whose calculated rank falls within a chosen range.

General Steps

1. Create a worksheet with a measure such as Sales.
2. Create or add a table calculation, such as a ranking calculation.
3. Place the calculated field on the Filters shelf.
4. Specify the required rank or calculated-value range.
5. Review the result and confirm how the filter affects the displayed marks.

Important: Because table calculation filters run after the relevant table calculations, they may not behave like dimension filters. If the calculation must retain values from records hidden in the view, check the calculation's scope and Tableau's order of operations.

13. Showing a Filter on a Worksheet

After adding a field to the Filters shelf, you can show a filter card so users can interact with the worksheet.

Steps

1. Add a field to the Filters shelf.
2. Open the field's menu on the Filters shelf.
3. Select Show Filter, if available.
4. Locate the filter card displayed in the worksheet.
5. Choose a suitable display style, such as a list, dropdown, or slider when supported.
6. Test the control by selecting different values.

Common Filter Card Styles

The exact styles available depend on the field type, filter configuration, and Tableau environment.

14. Interactive Filters in Dashboards

Interactive dashboard filters allow viewers to change the data shown in a dashboard without opening the underlying worksheet for editing.

How to Add a Filter to a Dashboard

1. Create a worksheet and configure the required filter.
2. Show the filter card on the worksheet.
3. Create or open a dashboard.
4. Add the worksheet to the dashboard.
5. Use the worksheet's menu on the dashboard to display its filter, if needed.
6. Position the filter card so it is easy to find.
7. Configure which worksheets should respond to the filter.
8. Test the dashboard with different selections.

Example

A company dashboard includes three views: Sales by Region, Profit by Category, and Monthly Sales Trend. A Region filter can allow viewers to focus on a specific region. If the filter should control all three views, configure its scope accordingly.

Filter Scope Options

• Current worksheet: Applies the filter only to the selected worksheet.
• Selected worksheets: Applies the filter to specified worksheets that use the relevant data source.
• All using this data source: Applies the filter to applicable worksheets that use the same data source, where supported.

Available scope options can vary by Tableau version and workbook configuration. Always test the dashboard to ensure that the intended worksheets respond to the filter.

15. Only Relevant Values

The Only Relevant Values option restricts the values displayed in a filter control to those that are relevant after other applicable filter selections.

Example

A dataset contains Region, Category, and Product. If a user selects the West region, a Product filter configured to show only relevant values can limit its available product choices to products relevant to the current selection.

Benefits

• Reduces the number of irrelevant choices in filter controls.
• Helps users navigate large lists of categories or products.
• Supports more intuitive dashboard interactions.
• Can make sequential filters easier to use.

Note: Only Relevant Values depends on the interaction of filters and the data in the view. If a filter has no relevant members after other selections, the list may be empty or have very few choices.

16. Keep Only and Exclude Options

Tableau provides quick filtering options directly from marks or headers in a view.

16.1 Keep Only

Keep Only retains the selected mark or member and removes other marks from the current view according to the resulting filter.

Example: Select the Technology mark in a category chart and choose Keep Only to focus the view on Technology.

16.2 Exclude

Exclude removes the selected mark or member from the current view.

Example: Exclude a category to focus the analysis on the remaining categories.

Steps

1. Create a visualization containing the data points or headers.
2. Select a mark or header.
3. Choose Keep Only or Exclude from the available tooltip or context controls.
4. Review the resulting view.

These operations create or modify filtering behavior for the view; they do not necessarily delete the corresponding records from the underlying data source.

17. Filters and Tableau's Order of Operations

Tableau evaluates filters in a defined sequence called the Order of Operations. This matters because filters applied at different stages can produce different results.

A simplified sequence of common filter stages is:

1. Extract filters
2. Data source filters
3. Context filters
4. Dimension filters
5. Measure filters
6. Table calculation filters

This is a simplified list of common filter stages, not the complete order of every operation in Tableau. Other operations, including certain date and level-of-detail calculation behavior, also affect the processing sequence.

Why Does the Order Matter?

Suppose a company wants to find the top 10 customers in the West region. If the Top 10 filter is evaluated against all customers before the region restriction is applied, the result may not be the top 10 customers within the West region.

Making Region a context filter can establish the required sequence so the Top N calculation is evaluated against the intended subset.

Practical Recommendation

When filters produce unexpected results, check the Order of Operations before assuming that the data is incorrect. Review whether a filter should be a context filter and whether calculations are evaluated before or after the filter.

18. Filters Versus Sorting

Filtering and sorting are different operations, although they are often used together in the same worksheet.

Combined Example

A sales manager wants to view the five highest-selling products in the West region.

1. Filter Region to West.
2. Sort products by SUM(Sales) in descending order.
3. Apply a Top 5 filter if only five products should be displayed.
4. Review the result to ensure the ranking is calculated for the intended region.

Sorting changes the order, while filtering determines which data remains in the analysis.

19. Common Filtering Mistakes and Solutions

20. Best Practices for Using Filters in Tableau

• Start with a clear business question before choosing filter fields.
• Use dimension filters for categories and member selection.
• Use measure filters for numerical ranges and thresholds.
• Use date filters that match the time period being analyzed.
• Display interactive filter cards only when they help viewers explore the data.
• Use suitable dropdowns or search controls for fields with many values.
• Use Only Relevant Values when it improves the filtering experience.
• Use context filters when the Order of Operations requires a specific sequence.
• Test filter scope when a dashboard contains multiple worksheets.
• Check how filters affect totals, percentages, rankings, and calculated fields.
• Use data source or extract filters when a restriction should apply at the appropriate data-processing level.
• Avoid adding unnecessary filters that make dashboards difficult to use.
• Check performance when filters are applied to large datasets.
• Validate the result after changing a filter, refreshing data, or modifying the workbook.

21. Hands-On Practice Exercises

Exercise 1: Filter by Region

Task: Create a sales chart and filter it to show only the West region.

Learning Outcome: Understand basic dimension filtering.

Exercise 2: Filter by Category

Task: Display only Technology and Furniture categories.

Learning Outcome: Practice selecting multiple dimension members.

Exercise 3: Filter by Sales Range

Task: Display sales values between 20,000 and 60,000.

Learning Outcome: Understand numerical measure filtering.

Exercise 4: Filter by Date

Task: Display orders from a specified quarter.

Learning Outcome: Practice filtering date fields.

Exercise 5: Create a Top 10 Filter

Task: Display the top 10 customers by SUM(Sales).

Learning Outcome: Understand Top N filtering.

Exercise 6: Use a Context Filter

Task: Display the top 10 customers within one selected region.

Learning Outcome: Understand why the Order of Operations matters.

Exercise 7: Create an Interactive Dashboard Filter

Task: Add a Region filter to a dashboard and configure it to affect the intended worksheets.

Learning Outcome: Practice interactive dashboard filtering.

22. Mini Project: Interactive Sales Analysis Dashboard

Project Objective: Create an interactive Tableau dashboard that enables users to analyze sales and profit by region, product category, and date.

Dataset Requirements

• Order ID
• Order Date
• Region
• Category
• Product Name
• Customer Name
• Sales
• Profit
• Quantity

Project Steps

1. Connect the dataset to Tableau.
2. Create a bar chart showing Sales by Region.
3. Create a chart showing Profit by Category.
4. Create a monthly sales trend using Order Date.
5. Add a Region filter.
6. Add a Category filter.
7. Add a suitable date filter.
8. Create a Top 10 customer view using SUM(Sales).
9. Use a context filter if required to calculate the Top 10 customers within a selected region.
10. Add the worksheets to a dashboard.
11. Configure filter scope so the intended charts respond to selections.
12. Test different combinations of region, category, and date filters.
13. Write three business observations based on the filtered views.

Expected Deliverables

• An interactive regional sales chart.
• A category profit comparison.
• A monthly sales trend.
• A Top 10 customer analysis.
• A dashboard with working filters and clearly displayed results.

Project Evaluation Checklist

• Does the Region filter display the correct data?
• Does the Category filter work as expected?
• Does the date filter select the intended period?
• Does the Top 10 view respond correctly to the relevant filters?
• Are filter cards easy to understand and use?
• Do the intended worksheets respond to dashboard selections?
• Are totals and calculations interpreted correctly after filtering?

23. Interview Questions and Answers

Q1. What is a filter in Tableau?

Answer: A filter restricts which data is included in a view or which marks are displayed according to specified conditions.

Q2. Why are filters used in Tableau?

Answer: Filters help users focus on relevant data, compare business segments, analyze specific time periods, and create interactive dashboards.

Q3. What is the difference between dimensions and measures in filtering?

Answer: Dimension filters commonly select categorical members, while measure filters typically apply numerical ranges or thresholds.

Q4. What is a dimension filter?

Answer: A dimension filter includes or excludes members of a categorical field, such as Region, Category, or Customer Name.

Q5. What is a measure filter?

Answer: A measure filter restricts quantitative values according to conditions such as a range, minimum, maximum, or null-value selection.

Q6. What is a date filter?

Answer: A date filter restricts data to selected dates, date ranges, date parts, or relative periods.

Q7. What is a context filter?

Answer: A context filter creates a primary subset of data that other relevant worksheet filters operate on. It can help when the order in which filters are evaluated matters.

Q8. What is a Top N filter?

Answer: A Top N filter restricts a dimension to a specified number of members based on a selected measure or ranking rule, such as the top 10 customers by sales.

Q9. What is the difference between extract filters and data source filters?

Answer: Extract filters limit the data included in an extract, while data source filters restrict the data available from the data source to the workbook.

Q10. What is a table calculation filter?

Answer: A table calculation filter filters results after the relevant table calculations are evaluated and generally hides marks without filtering out the underlying data used in those calculations.

Q11. What does Only Relevant Values do?

Answer: It limits the choices shown in a filter control to values relevant after other applicable filter selections.

Q12. What is the difference between Keep Only and Exclude?

Answer: Keep Only retains the selected member or mark in the view, while Exclude removes the selected member or mark from the view.

Q13. Can a filter be applied to multiple worksheets?

Answer: Yes. Where supported, a filter can be configured to apply to selected worksheets or applicable worksheets using the same data source.

Q14. Why might a Top N filter show unexpected results?

Answer: The issue may be related to Tableau's Order of Operations. A context filter can be useful when another dimension filter must be evaluated before the Top N filter.

Q15. What is the difference between filtering and sorting?

Answer: Filtering restricts the data included in the view, whereas sorting rearranges the order of the displayed members.

Q16. Do worksheet filters delete records from the original dataset?

Answer: No. A worksheet filter generally controls the data included in the view or analysis. It does not ordinarily delete records from the underlying source.

24. Quick Revision Notes

• Filters restrict the data displayed or analyzed in Tableau.
• Dimensions commonly contain categories, names, and other descriptive values.
• Measures contain quantitative values such as Sales and Profit.
• Dimension filters select or exclude members.
• Measure filters apply numerical conditions or ranges.
• Date filters support relative periods, fixed ranges, and individual dates.
• Extract filters restrict data included in an extract.
• Data source filters restrict data available from the source to the workbook.
• Context filters establish a primary subset for relevant worksheet filters.
• Top N filters select a specified number of members based on a measure or ranking rule.
• Table calculation filters operate after the relevant table calculations.
• Show Filter displays a filter card when supported.
• Interactive dashboard filters allow users to explore data.
• Only Relevant Values can reduce irrelevant choices in a filter control.
• Keep Only retains selected marks or members, while Exclude removes them from the view.
• The Order of Operations affects how filters interact with calculations and other filters.

25. Final Checklist

• Understand the purpose of filters in Tableau.
• Know the difference between dimensions and measures.
• Create a dimension filter.
• Create a measure filter using a range or threshold.
• Filter data by dates.
• Configure a Top N filter.
• Understand extract, data source, context, dimension, measure, and table calculation filters.
• Show a filter card on a worksheet.
• Configure filters on a dashboard.
• Understand how Only Relevant Values works.
• Practice Keep Only and Exclude.
• Understand the basic Order of Operations.
• Complete the interactive sales dashboard project.

26. Conclusion

Filters are fundamental to Tableau because they help users focus on the data that matters to a particular business question. By learning dimension, measure, date, context, extract, data source, and table calculation filters, users can build focused worksheets and interactive dashboards.

The most important skill is choosing the appropriate filter type and understanding how it interacts with other filters and calculations. Always test the results, especially when using Top N filters, context filters, and calculations that depend on the data visible in the view.

Recommended Learning Resources

• Official Tableau Help: Filter Data from Your Views
• Official Tableau Help: Tableau's Order of Operations
• Official Tableau Help: Filter Actions
• JustAcademy Tableau Training
• Register for a Tableau Course Demo

Next Step: Create a Tableau worksheet with Region, Category, Sales, and Order Date. Add a dimension filter, a numerical measure filter, and a date filter, then combine them in an interactive dashboard and verify the results.